

IF NOT EXISTS(SELECT * FROM sys.databases  WHERE database_id = DB_id(N'PerformanceTest'))
	CREATE DATABASE PerformanceTest
GO
USE PerformanceTest
GO
IF EXISTS(SELECT * FROM sys.objects  WHERE [object_id]=OBJECT_ID(N'Request'))
	DROP TABLE Request
GO
CREATE TABLE Request
(
	RequestID	INT IDENTITY(1,1),
	URL			NVARCHAR(2000),
	Location	NVARCHAR(100),
	NetworkLatency			INT,
	ServerThinkingTime		INT,
	ElapsedTime				INT,
	RequestTime				DATETIME,
	RequestTime2			DATETIME,
	CONSTRAINT PK_Request PRIMARY KEY 
	(RequestID)
)


